According to the customer's needs, we have added a statistical table to collect statistics and generate statistical data. We need to dynamically Execute SQL statements based on a basic table. the execute immediate command is used to dynamically generate and execute SQL statements during the storage process. I want to write a general Stored Procedure for statistics. It seems that it is not easy to use. The application of if statements is inevitable. haha.
It is hereby archived.
Create or replace
In various programming languages, the method for obtaining the number of daffodils (non-precision) is realized ).PHP "Daffodils" implementation code Int main ()
{
Int I, D1, Hub, transit;
For (I = 100; I
{
For (hub = 0, transit = I, d1 = 123; transit! = 0 ;)
{
D1 = (transit % 10) * (transit % 10) * (transit % 10 ); /* You need to add a loop for Multiple Digits. I am too lazy to change it. */hub = hub + D1;
Transit = transit/10;
}
If (hub = I) printf ("daffodils % d \ n", I );
' ==========b
Reported an error! Description using the SXH component to load an XML document asynchronously is not allowed! The error is described as: -1072897486-the serverhttprequest property can, used when loading a document asynchronously and are only SUP Ported on Windows NT 4.0 and above.
case Fourth (correct use):
If you explicitly declare that the Async property is False, the XML document is loaded synchronously. And the ServerX
://www.w3.org/1999/xsl/transform "
3.Finally, create a file that contains the following code and is named Books.asp. This file is used only to create the XMLHTTP object, load the XML file for it, and write the resulting HTML to the response stream.
Dim sxhResponse.ContentType = "Text/xml"Set sxh = Server.CreateObject ("MSXML2. xmlhttp.3.0 ")Sxh.open "Get", "http://localhost/books.xml", FalseSxh.sendResponse.Write Sxh.response
#include #include//number of daffodils--everybody cubic and equal to itselfvoidsxh () {intx, Y, Z printf ("find the three-digit number of daffodils \ n"); for(intI= -; i999; i++) {x= i/ -; Y= i% -/Ten; Z= i% -%Ten; if(i = = x*x*x + y*y*y + z*z*z) printf ("%d,", i); } printf ("\ n");}//determine if a number is primevoidIspri () {intx; BOOLIsP =true; printf ("Enter a number to determine if it is prime!\n"); scanf ("%d",x); for(intI=1; i) { if(x%i = =0 I! =1) IsP=false; } if(IsP) pri
[Csharp] view plaincopy/* (Start of program header annotation) * Copyright (c) 2011, a student from the computer College of Yantai University* Author: Li Zhaoqing* Completion date: January 1, September 9, 2012* Input description:* Problem description and output: Write a c # application to output all the daffodils.* Knowledge expansion: the number of daffodils is only a kind of self-Power. Strictly speaking, the three power numbers of three numbers become the number of daffodils.* Other-digit sel
not exist within the given range, the output is no;the output for each test instance takes one row. Sample Input About380Sample OutputNo370 371AuthorLCYSourceC language Programming exercises (II.)recommendjgshiningTopic Description: In a given interval, to meet the problem conditions (Narcissus number) output! 1#include 2#include 3#include 4 using namespacestd;5 BOOLSXH (intN)6 {7 intK,r =0, M =N;8 9 while(N >0 )Ten { OneK = n%Ten; AR + = k*k*K; -N/=Ten; - } the returnr = =
.
2.Then, create a file that contains the following code and is named Books.xsl. This file is the style sheet referenced by the books.xml created in step 1th. It contains the information necessary to correctly format the above XML file as an HTML page, even including scripts on that HTML page.
Xmlns:xsl= "Http://www.w3.org/1999/XSL/Transform">
3.Finally, create a file that contains the following code and is named Books.asp. This file is used only to create the XMLHTTP object, load the XML f
Contact Us
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.